﻿CREATE TABLE [dbo].[RegistrationLog] (
LogId INT IDENTITY (1, 1) NOT NULL,
LogDate [datetime] NOT NULL,
Thread [varchar] (50) NOT NULL,
LogLevel [varchar] (200) NOT NULL,
Logger [varchar] (200) NOT NULL,
LogMessage [varchar] (2000) NOT NULL,
EXCEPTION [varchar] (4000) NULL
)
GO

CREATE TABLE [dbo].[Log] ( 
    [ID] [int] IDENTITY (1, 1) NOT NULL ,
    [Date] [datetime] NOT NULL ,
    [Thread] [varchar] (255) NOT NULL ,
    [Level] [varchar] (20) NOT NULL ,
    [Logger] [varchar] (255) NOT NULL ,
    [Message] [varchar] (4000) NOT NULL 
) ON [PRIMARY]